package com.apartmentManage.dao;

import com.apartmentManage.entity.IntoPersonnel;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface IntoPersonnelDao {
    /*添加*/
    int save(@Param("intoPersonnel") IntoPersonnel intoPersonnel);

    /*添加房间*/
    int saveRoom(@Param("intoPersonnel") IntoPersonnel intoPersonnel);

    /*修改*/
    int update(@Param("intoPersonnel") IntoPersonnel intoPersonnel);

    /*删除*/
    int delete(@Param("sno") String sno);

    /*查询所有*/
    List<IntoPersonnel> getAll();

    /*根据no查询*/
    IntoPersonnel getByNo(@Param("sno") String sno);

    /*条件模糊查询*/
    List<IntoPersonnel> getByRequirement(@Param("intoPersonnel") IntoPersonnel intoPersonnel);

    /*查询所有的No*/
    List<String> getAllNo();
}
